﻿create procedure [dbo].[usp_TeamFoundationServerUpdate]
	@TeamFoundationServerId int
	, @ConcurrencyId rowversion
	, @Uri nvarchar(1024)
as

begin try
	
	begin transaction
	
		update [dbo].[TeamFoundationServer]
		set
			[Uri] = @Uri
		where TeamFoundationServerId = @TeamFoundationServerId and ConcurrencyId = @ConcurrencyId
		
	commit transaction

end try
	
begin catch
	if @@trancount > 0
	begin
		rollback transaction;
	end
	execute [dbo].[usp_SqlErrorInsert]
end catch


